﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using NetWing.Common.Data.SqlServer;

namespace NetWing.BPM.Admin.mjprint
{
    public partial class zcht : System.Web.UI.Page
    {
        public string mainKeyId = "";
        public DataTable dtmain = null;
        public DataTable dtdetail = null;
        public DataTable dtyj = null;//押金
        protected void Page_Load(object sender, EventArgs e)
        {
            mainKeyId = Request["KeyId"];
            string sqlmain = "select * from MJOrder where KeyId=" + mainKeyId + "";
            dtmain = SqlEasy.ExecuteDataTable(sqlmain);
            //得到用户租车信息
            string sqldetail = "select * from MJOrderDetail where MJOrderid=" + mainKeyId + " and serviceid=14 order by KeyId asc";
            dtdetail = SqlEasy.ExecuteDataTable(sqldetail);
        }
    }
}